--==============================================
--Author Panny
--date   2009/3/28
--Dec   select all city in the region of the agents 
--===============================================
ALTER PROCEDURE dbo.Pro_Agent_Pan_SelectByCity
	@City 	varchar(50)
AS
BEGIN
	SELECT AgentID,LoginName,AgentName,Linkman,Address,Nearby,City,WorkHours
    	 FROM TT_Agent WHERE City = @City;
 -- SELECT EXISTS City FROM TT_Agent 
END
GO
